Web scrapping website: https://towardsdatascience.com/web-scraping-scraping-table-data-1665b6b2271c
Variables:
Number of tables on site: 2
['SampleDatetime', 'Timedatum\xa0', 'Timedatumreliabilitycode\xa0', 'SampleMediumCode\xa0', 'AgencyCollectingSample,Code\xa0', ' Stream width, feet(00004)', ' Loca-tion inX-sect.lookingdwnstrmft from l bank(00009)', ' Temper- ature, water, deg C(00010)', ' Temper- ature, air, deg C(00020)', ' Baro- metric pres- sure, mm Hg(00025)', ' Instan-taneous dis-charge, ft3/s(00061)', ' Gageheight, feet(00065)', ' Turbid- ity, JTU(00070)', ' Color, water, fltrd, Pt-Co units(00080)', 'Specif- icconduc- tance,wat unfuS/cm @25 degC(00095)', ' Hydro- gen ion, water,unfltrd calcd, mg/L(00191)', ' Dis- solvedoxygen, mg/L(00300)', ' Dis- solvedoxygen,percentof sat-uration(00301)', ' pH, water,unfltrd field, std units(00400)', ' Carbondioxide water,unfltrd mg/L(00405)', ' ANC,wat unf fixedend pt, field,mg/L as CaCO3(00410)', ' Bicar-bonate,wat unf fixedend pt, field, mg/L(00440)', 'Carbon- ate,wat unf fixedend pt, field, mg/L(00445)', ' Nitrate water, fltrd, mg/L as N(00618)', 'Nitrate +nitrite water, fltrd, mg/L as N(00631)', ' Ortho- phos- phate, water, fltrd, mg/L(00660)', ' Ortho- phos- phate, water, fltrd, mg/L as P(00671)', ' Organiccarbon, water,unfltrd mg/L(00680)', ' Hard- ness, water,mg/L as CaCO3(00900)', 'Noncarb hard- ness,wat unf field,mg/L as CaCO3(00902)', ' Calcium water, fltrd, mg/L(00915)', ' Magnes- ium, water, fltrd, mg/L(00925)', ' Sodium, water, fltrd, mg/L(00930)', ' Sodiumadsorp- tion ratio(00931)', ' Sodium frac- tion ofcationspercent(00932)', ' Potas- sium, water, fltrd, mg/L(00935)', ' Chlor- ide, water, fltrd, mg/L(00940)', ' Sulfate water, fltrd, mg/L(00945)', ' Fluor- ide, water, fltrd, mg/L(00950)', ' Silica, water, fltrd,mg/L as SiO2(00955)', ' Iron, water, fltrd, ug/L(01046)', ' Manga- nese, water, fltrd, ug/L(01056)', ' Gage height above datum meters(30207)', ' Dis-charge,instan-taneous m3/s(30209)', ' Fecal coli- form, M-FC0.7u MF cfu/ 100 mL(31625)', ' Fecal strep-tococci KF MF, cfu/ 100 mL(31673)', ' Dis- solved solidsdried @180degCwat flt mg/L(70300)', ' Dis- solvedsolids,sum ofconsti-tuents, mg/L(70301)', ' Dis- solvedsolids, water, ton/d(70302)', ' Dis- solvedsolids, water, tons/acre-ft(70303)', ' Nitrate water, fltrd, mg/L(71851)', ' Iron, water,unfltrd ug/L(71885)', ' Samplepurpose code(71999)', ' Sam- plingmethod, code(82398)']
Index(['SampleDatetime', 'Time datum', 'Time datum reliability code',
'Sample Medium Code', 'Agency Collecting Sample,Code',
'Stream width(ft)',
'Location intersect (lookingdwnstream) from l bank)',
'Temperature,water(C)(00010)', 'Temperature,air(C)(00020)',
'Barometric pressure,(mmHg)(00025)',
'Instantaneous_discharge(ft3/s)(00061)', 'Gageheight_feet(00065)',
'Turbidity,(JTU)(00070)', 'Color, water, fltrd, Pt-Co units(00080)',
'Specific_conductance,wat unfuS/cm @25 degC(00095)',
'Hydrogen_ion,water,unfltrd calcd,mg/L(00191)',
'Dissolved_oxygen,(mg/L)(00300)',
'Dissolved_oxygen,percent of saturation(00301)',
'pH, water,unfltrd field, std units(00400)',
'Carbon_dioxide water,unfltrd mg/L(00405)',
'ANC,wat unffixedend pt, field,mg/L as CaCO3(00410)',
'Bicarbonate,wat unf fixedend pt, field, mg/L(00440)',
'Carbonate,wat unf fixedend pt, field, mg/L(00445)',
'Nitrate water, fltrd, mg/L as N(00618)',
'Nitrate+nitrite water, fltrd, mg/L as N(00631)',
'Ortho-phosphate, water, fltrd, mg/L(00660)',
'Ortho-phosphate, water, fltrd, mg/L as P(00671)',
'Organic_carbon, water,unfltrd mg/L(00680)',
'Hardness, water,mg/L as CaCO3(00900)',
'Noncarb hardness,wat unf field,mg/L as CaCO3(00902)',
'Calcium water, fltrd, mg/L(00915)',
'Magnesium, water, fltrd, mg/L(00925)',
'Sodium, water, fltrd, mg/L(00930)', 'Sodium_adsorption ratio(00931)',
'Sodium fraction of cations percent(00932)',
'Potassium, water, fltrd, mg/L(00935)',
'Chloride, water, fltrd, mg/L(00940)',
'Sulfate water, fltrd, mg/L(00945)',
'Fluoride, water, fltrd, mg/L(00950)',
'Silica, water, fltrd,mg/L as SiO2(00955)',
'Iron, water, fltrd, ug/L(01046)',
'Manga- nese, water, fltrd, ug/L(01056)', 'Gage_height_meters(30207)',
'Discharge_instantaneous(m3/s)(30209)',
'Fecal coli-form,M-FC0.7u MF cfu/ 100 mL(31625)',
'Fecal streptococci KF MF, cfu/ 100 mL(31673)',
'Dissolved_solids_dried @180degCwat flt mg/L(70300)',
'Dissolved_solids, sum of constituents, mg/L(70301)',
'Dissolved_solids, water, ton/d(70302)',
'Dissolved_solids, water, tons/acre-ft(70303)',
'Nitrate water, fltrd, mg/L(71851)',
'Iron, water,unfltrd ug/L(71885)', 'Sample purpose code(71999)',
'Sampling method code(82398)'],
dtype='object')Number of tables on site: 1
['Meas.Number', '\xa0 Date \xa0 \xa0 \xa0 Time', 'TimeDatum', 'MeasurementUsed?', ' \xa0 Who', 'MeasuringAgency', 'Streamflow(ft3/s)', 'GageHeight(ft)', 'GHChange(ft)', 'Meas.Duration(hr)', 'Meas.Rated', ' \xa0 Control', 'FlowAdjust.Code\xa0']
variable : 'USGS_Colville_hist'
NOTE: You could probably go back more for this data set but this is set to 2016 to not crash the page
Number of tables on site: 1
['Date / Time', ' Dis-charge, ft3/s,', ' Precip-itation total, inches,', ' Temper- ature, air, deg C,', ' Gageheight, feet,', ' Gageheight, feet,[Secondary]']
Variables:
Number of tables on site: 3
['SampleDatetime', 'Timedatum\xa0', 'Timedatumreliabilitycode\xa0', 'SampleMediumCode\xa0', 'AgencyCollectingSample,Code\xa0', 'Hydro-logicEvent\xa0', 'Hydro-logicCondition\xa0', 'Sampletype\xa0', 'ProjectCode', ' Sam- pling depth, feet(00003)', ' Stream width, feet(00004)', ' Loca-tion inX-sect.lookingdwnstrmft from l bank(00009)', ' Temper- ature, water, deg C(00010)', ' Temper- ature, air, deg C(00020)', ' Expo- sure time, sample or test, days(00022)', ' Baro- metric pres- sure, mm Hg(00025)', ' Agency ana-lyzingsample, code(00028)', ' Surface area, mi2(00049)', ' Instan-taneous dis-charge, ft3/s(00061)', ' Gageheight, feet(00065)', ' Turbid- ity, JTU(00070)', ' Turbid- ity, NTU(00076)', ' Color, water, fltrd, Pt-Co units(00080)', 'Specif- icconduc- tance,wat unfuS/cm @25 degC(00095)', ' Hydro- gen ion, water,unfltrd calcd, mg/L(00191)', ' Dis- solvedoxygen, mg/L(00300)', ' Dis- solvedoxygen,percentof sat-uration(00301)', ' pH, water,unfltrd field, std units(00400)', ' pH, water,unfltrd lab, std units(00403)', ' Carbondioxide water,unfltrd mg/L(00405)', ' ANC,wat unf fixedend pt, field,mg/L as CaCO3(00410)', ' Bicar-bonate,wat unf fixedend pt, field, mg/L(00440)', 'Carbon- ate,wat unf fixedend pt, field, mg/L(00445)', ' Peri- phytonbiomass ashweight, g/m2(00572)', ' Peri- phytonbiomass dryweight, g/m2(00573)', ' Total nitro- gen, water,unfltrd mg/L(00600)', ' Total nitro- gen, water, fltrd, mg/L(00602)', ' Organic nitro- gen, water,unfltrd mg/L(00605)', ' Organic nitro- gen, water, fltrd, mg/L(00607)', ' Ammonia water, fltrd, mg/L as N(00608)', ' Ammonia water,unfltrd mg/L as N(00610)', ' Nitrite water, fltrd, mg/L as N(00613)', ' Nitrate water, fltrd, mg/L as N(00618)', 'Ammonia + org-N, water, fltrd, mg/L as N(00623)', 'Ammonia + org-N,sus sed total, mg/L as N(00624)', 'Ammonia + org-N, water,unfltrd mg/L as N(00625)', 'Nitrate +nitrite waterunfltrd mg/L as N(00630)', 'Nitrate +nitrite water, fltrd, mg/L as N(00631)', ' Phos- phate, water,unfltrd mg/L(00650)', ' Ortho- phos- phate, water, fltrd, mg/L(00660)', ' Phos-phorus, water,unfltrd mg/L as P(00665)', ' Phos-phorus, water, fltrd, mg/L as P(00666)', ' Ortho- phos- phate, water, fltrd, mg/L as P(00671)', ' Organiccarbon, water,unfltrd mg/L(00680)', ' Organiccarbon, water, fltrd, mg/L(00681)', ' Organiccarbon, suspndsedimnt total, mg/L(00689)', ' Hard- ness, water,mg/L as CaCO3(00900)', 'Noncarb hard- ness,wat unf field,mg/L as CaCO3(00902)', ' Calcium water, fltrd, mg/L(00915)', ' Magnes- ium, water, fltrd, mg/L(00925)', ' Sodium, water, fltrd, mg/L(00930)', ' Sodiumadsorp- tion ratio(00931)', ' Sodium frac- tion ofcationspercent(00932)', ' Sodium+ potas sium, water, fltrd, mg/L as Na(00933)', ' Potas- sium, water, fltrd, mg/L(00935)', ' Chlor- ide, water, fltrd, mg/L(00940)', ' Sulfate water, fltrd, mg/L(00945)', ' Fluor- ide, water, fltrd, mg/L(00950)', ' Silica, water, fltrd,mg/L as SiO2(00955)', ' Arsenic water, fltrd, ug/L(01000)', ' Arsenic suspndsedimnt total, ug/L(01001)', ' Arsenic water,unfltrd ug/L(01002)', ' Barium, water, fltrd, ug/L(01005)', ' Barium, suspndsedimntrecover -able, ug/L(01006)', ' Barium, water,unfltrdrecover -able, ug/L(01007)', ' Beryll- ium, water, fltrd, ug/L(01010)', ' Cadmium water, fltrd, ug/L(01025)', ' Cadmium suspndsedimntrecover -able, ug/L(01026)', ' Cadmium water,unfltrd ug/L(01027)', ' Chrom- ium, water, fltrd, ug/L(01030)', ' Chrom- ium, suspndsedimntrecover -able, ug/L(01031)', ' Chrom- ium, water,unfltrdrecover -able, ug/L(01034)', ' Cobalt water, fltrd, ug/L(01035)', ' Cobalt suspndsedimntrecover -able, ug/L(01036)', ' Cobalt water,unfltrdrecover -able, ug/L(01037)', ' Copper, water, fltrd, ug/L(01040)', ' Copper, suspndsedimntrecover -able, ug/L(01041)', ' Copper, water,unfltrdrecover -able, ug/L(01042)', ' Iron, suspndsedimntrecover -able, ug/L(01044)', ' Iron, water,unfltrdrecover -able, ug/L(01045)', ' Iron, water, fltrd, ug/L(01046)', ' Lead, water, fltrd, ug/L(01049)', ' Lead, suspndsedimntrecover -able, ug/L(01050)', ' Lead, water,unfltrdrecover -able, ug/L(01051)', ' Manga- nese, suspndsedimntrecover -able, ug/L(01054)', ' Manga- nese, water,unfltrdrecover -able, ug/L(01055)', ' Manga- nese, water, fltrd, ug/L(01056)', ' Molyb- denum, water, fltrd, ug/L(01060)', ' Nickel, water, fltrd, ug/L(01065)', ' Nickel, suspndsedimntrecover -able, ug/L(01066)', ' Nickel, water,unfltrdrecover -able, ug/L(01067)', ' Silver, water, fltrd, ug/L(01075)', ' Silver, suspndsedimntrecover -able, ug/L(01076)', ' Silver, water,unfltrdrecover -able, ug/L(01077)', ' Stron- tium, water, fltrd, ug/L(01080)', ' Vana- dium, water, fltrd, ug/L(01085)', ' Zinc, water, fltrd, ug/L(01090)', ' Zinc, suspndsedimntrecover -able, ug/L(01091)', ' Zinc, water,unfltrdrecover -able, ug/L(01092)', ' Alum- inum, water, fltrd, ug/L(01106)', ' Lithium water, fltrd, ug/L(01130)', ' Selen- ium, water, fltrd, ug/L(01145)', ' Selen- ium, suspndsedimnt total, ug/L(01146)', ' Selen- ium, water,unfltrd ug/L(01147)', ' Gage height above datum meters(30207)', ' Dis-charge,instan-taneous m3/s(30209)', ' Fecal coli- form, M-FC0.45uMF cfu/ 100 mL(31616)', ' Fecal coli- form, M-FC0.7u MF cfu/ 100 mL(31625)', ' Fecal strep-tococci KF MF, cfu/ 100 mL(31673)', ' Fecal strep-tococcim-Enterococcus col/ 100 mL(31679)', ' Chloro-phyll b peri-phyton,uncorr, mg/m2(32226)', ' Chloro-phyll a peri-phyton,uncorr, mg/m2(32228)', ' Biomass peri-phyton,ashfreedrymass g/m2(49954)', ' Phyto- plank- ton, total, cells /mL(60050)', ' Dis- solved solidsdried @180degCwat flt mg/L(70300)', ' Dis- solvedsolids,sum ofconsti-tuents, mg/L(70301)', ' Dis- solvedsolids, water, ton/d(70302)', ' Dis- solvedsolids, water, tons/acre-ft(70303)', 'Suspnd.sedimnt sievediametrpercent<0.0625 mm(70331)', 'Suspnd. sedi- ment, sievediametrpercent<.125mm(70332)', 'Suspnd. sedi- ment, sievediametrpercent <.25mm(70333)', 'Suspnd. sedi- ment, sievediametrpercent <.5 mm(70334)', 'Suspnd. sedi- ment,falldiadst watpercent<.002mm(70337)', 'Suspnd. sedi- ment,falldiadst watpercent<.004mm(70338)', 'Suspnd. sedi- ment,falldiadst watpercent<.008mm(70339)', 'Suspnd. sedi- ment,falldiadst watpercent<.016mm(70340)', 'Suspnd. sedi- ment,falldiadst watpercent<.031mm(70341)', ' Ortho- phos- phate, water,unfltrd mg/L as P(70507)', 'Biomasschloro- phyll ratio, peri-phyton, number(70950)', 'Chloro-phyll a peri-phyton,chromo-fluoro, mg/m2(70957)', 'Chloro-phyll b peri-phyton,chromo-fluoro, mg/m2(70958)', ' Ammonia water,unfltrd mg/L(71845)', ' Ammonia water, fltrd, mg/L(71846)', ' Nitrate water, fltrd, mg/L(71851)', ' Nitrite water, fltrd, mg/L as NO2(71856)', ' Manga- nese, water,unfltrd ug/L(71883)', ' Iron, water,unfltrd ug/L(71885)', ' Phos-phorus, water,unfltrd mg/L as PO4(71886)', ' Total nitro- gen, water,unfltrd mg/L as NO3(71887)', ' Mercury water, fltrd, ug/L(71890)', ' Mercury suspndsedimntrecover -able, ug/L(71895)', ' Mercury water,unfltrdrecover -able, ug/L(71900)', ' Samplepurpose code(71999)', ' Sample loc- ation, crosssectionft fromrt bank(72103)', ' Sus- pended sedi- mentconcen-tration mg/L(80154)', ' Sus- pended sedi- ment dis-charge, ton/d(80155)', ' K-40, water, fltrd, pCi/L(82068)', ' Sam- plingmethod, code(82398)', 'Specif.conduc- tance,wat unf lab,uS/cm @25 degC(90095)', ' ANC,wat unf fixedend pt, lab,mg/L as CaCO3(90410)', ' Con-versionfactor, number(95100)', ' Total cell count, cells/ mL(95200)', ' Noncarb hard- ness, water,mg/L as CaCO3(95902)', ' CHLAMYDOMONAS#/mL(96014)', ' RPTEROMONAS#/mL(96029)', ' CHLOROCOCCUM#/mL(96167)', ' SCHROEDERIA#/mL(96190)', ' ANKISTRODESMUS#/mL(96202)', ' SCENEDESMUS#/mL(96243)', ' TETRASTRUM#/mL(96245)', ' GOLENKINIA#/mL(96252)', ' MOUGEOTIA#/mL(96294)', ' ZYGNEMA#/mL(96299)', ' COSMARIUM#/mL(96313)', ' TRACHELOMONAS#/mL(96392)', ' CRYPTOMONAS#/mL(96416)', ' CRYPTOMONAS#/mL(96430)', ' GYMNODINIUM#/mL(96454)', ' PERIDINIUM#/mL(96487)', ' MALLOMONAS#/mL(96595)', ' DINOBYRON#/mL(96605)', ' OCHROMONAS#/mL(96608)', ' CYCLOTELLA#/mL(96706)', ' MELOSIRA#/mL(96707)', ' TABELLARIA#/mL(96750)', ' DIATOMA#/mL(96759)', ' ASTERIONELLA#/mL(96763)', ' FRAGILARIA#/mL(96764)', ' SYNEDRA#/mL(96765)', ' HANNAEA#/mL(96766)', ' H.ARCUS#/mL(96767)', ' EUNOTIA#/mL(96775)', ' ACHNANTHES#/mL(96777)', ' NAVICULA#/mL(96791)', ' NEIDIUM#/mL(96792)', ' PINNULARIA#/mL(96793)', ' STAURONEIS#/mL(96795)', ' GOMPHONEMA#/mL(96802)', ' AMPHORA#/mL(96805)', ' CYMBELLA#/mL(96806)', ' NITZSCHIA#/mL(96812)', ' SURIRELLA#/mL(96817)', ' ANACYSTIS#/mL(98082)', ' AGMENELLUM#/mL(98090)', ' OSCILLATORIA#/mL(98136)', ' SCHIZOTHRIX#/mL(98150)', ' ANABAENA#/mL(98165)', ' APHANIZOMENON#/mL(98167)', 'Carbon- ate,wat unfinf tit field,mg/L as CaCO3(99430)', ' Bicar-bonate,wat unfinfl pt titr., field, mg/L(99440)']
SampleDatetime datetime64[ns]
Time datum object
Time datum reliability code object
Sample Medium Code object
Agency Collecting Sample, Code object
...
SCHIZOTHRIX#/mL(98150) object
ANABAENA#/mL(98165) object
APHANIZOMENON#/mL(98167) object
Carbonate,wat unfinf tit field,mg/L as CaCO3(99430) float64
Bicarbonate,wat unfinfl pt titr., field, mg/L(99440) float64
Length: 210, dtype: objectvariable: 'USGS_Kuparuk_Month_Discharge'
Number of tables on site: 1
['Meas.Number', '\xa0 Date \xa0 \xa0 \xa0 Time', 'TimeDatum', 'MeasurementUsed?', ' \xa0 Who', 'MeasuringAgency', 'Streamflow(ft3/s)', 'GageHeight(ft)', 'GHChange(ft)', 'Meas.Duration(hr)', 'Meas.Rated', ' \xa0 Control', 'FlowAdjust.Code\xa0']
['Meas.Number', '\xa0 Date \xa0 \xa0 \xa0 Time', 'TimeDatum', 'MeasurementUsed?', ' \xa0 Who', 'MeasuringAgency', 'Streamflow(ft3/s)', 'GageHeight(ft)', 'GHChange(ft)', 'Meas.Duration(hr)', 'Meas.Rated', ' \xa0 Control', 'FlowAdjust.Code\xa0']
variable : 'USGS_Kuparuk_hist'
Number of tables on site: 1
['Date / Time', ' Temper- ature, water, deg C,', ' Dis-charge, ft3/s,', ' Gageheight, feet,']
/usr/local/lib/python3.7/dist-packages/dateutil/parser/_parser.py:1212: UnknownTimezoneWarning: tzname AKDT identified but not understood. Pass `tzinfos` argument in order to correctly return a timezone-aware datetime. In a future version, this will raise an exception. /usr/local/lib/python3.7/dist-packages/dateutil/parser/_parser.py:1212: UnknownTimezoneWarning: tzname AKST identified but not understood. Pass `tzinfos` argument in order to correctly return a timezone-aware datetime. In a future version, this will raise an exception.
Index(['Discharge_ft2/s', 'Precipitation_total_in', 'Temperature_air_C',
'Gageheight_ft', 'Gageheight_ft_2'],
dtype='object')Variables:
variable = 'USGS_Sagavanirtok_water'
Latitude 69°00'57", Longitude 148°49'04" NAD83 Drainage area 1,850 square miles Gage datum 1,117.35 feet above NAVD88
Number of tables on site: 1
['SampleDatetime', 'Timedatum\xa0', 'Timedatumreliabilitycode\xa0', 'SampleMediumCode\xa0', 'AgencyCollectingSample,Code\xa0', ' Stream width, feet(00004)', ' Loca-tion inX-sect.lookingdwnstrmft from l bank(00009)', ' Temper- ature, water, deg C(00010)', ' Temper- ature, air, deg C(00020)', ' Instan-taneous dis-charge, ft3/s(00061)', ' Gageheight, feet(00065)', ' Gage height above datum meters(30207)', ' Dis-charge,instan-taneous m3/s(30209)', ' Samplepurpose code(71999)', ' Sam- plingmethod, code(82398)']
SampleDatetime datetime64[ns] Time datum object Time datum reliability code object Sample Medium Code object Agency Collecting Sample, Code object Stream width (ft) int64 Location intersect (lookingdwnstream) from l bank) float64 Temperature,water(C)(00010) float64 Temperature,air(C)(00020) float64 Instantaneous_discharge(ft3/s)(00061) int64 Gageheight_feet(00065) float64 Gage_height_meters(30207) float64 Discharge_instantaneous(m3/s)(30209) int64 Sample purpose code(71999) float64 Sampling method code(82398) int64 dtype: object
variable: 'USGS_Sagavanirtok_Month_Discharge'
variable = 'USGS_Sagavanirtok_annual'
variable = 'USGS_Sagavanirtok_discharge'
Number of tables on site: 1
['Meas.Number', '\xa0 Date \xa0 \xa0 \xa0 Time', 'TimeDatum', 'MeasurementUsed?', ' \xa0 Who', 'MeasuringAgency', 'Streamflow(ft3/s)', 'GageHeight(ft)', 'GHChange(ft)', 'Meas.Duration(hr)', 'Meas.Rated', ' \xa0 Control', 'FlowAdjust.Code\xa0']
['Meas.Number', '\xa0 Date \xa0 \xa0 \xa0 Time', 'TimeDatum', 'MeasurementUsed?', ' \xa0 Who', 'MeasuringAgency', 'Streamflow(ft3/s)', 'GageHeight(ft)', 'GHChange(ft)', 'Meas.Duration(hr)', 'Meas.Rated', ' \xa0 Control', 'FlowAdjust.Code\xa0']
variable : 'USGS_Sagavanirtok_hist'
Number of tables on site: 1
['Date / Time', ' Dis-charge, ft3/s,', ' Gageheight, feet,', ' Temper- ature, water, deg C,']
/usr/local/lib/python3.7/dist-packages/dateutil/parser/_parser.py:1212: UnknownTimezoneWarning: tzname AKDT identified but not understood. Pass `tzinfos` argument in order to correctly return a timezone-aware datetime. In a future version, this will raise an exception. /usr/local/lib/python3.7/dist-packages/dateutil/parser/_parser.py:1212: UnknownTimezoneWarning: tzname AKST identified but not understood. Pass `tzinfos` argument in order to correctly return a timezone-aware datetime. In a future version, this will raise an exception.
Index(['Discharge_ft2/s', 'Gageheight_ft', 'Temperature_water_C'], dtype='object')
SampleDatetime datetime64[ns] Stream width (ft) float64 Temperature,water(C)(00010) float64 Temperature,air(C)(00020) float64 Instantaneous_discharge(ft3/s)(00061) float64 Gageheight_feet(00065) float64 Gage_height_meters(30207) float64 Discharge_instantaneous(m3/s)(30209) float64 Discharge_ft2/s float64 Gageheight_ft float64 Temperature_water_C float64 dtype: object
Index(['Stream width(ft)', 'Temperature,water(C)(00010)',
'Temperature,air(C)(00020)', 'Instantaneous_discharge(ft3/s)(00061)',
'Gageheight_feet(00065)', 'Color, water, fltrd, Pt-Co units(00080)',
'Specific_conductance,wat unfuS/cm @25 degC(00095)',
'Hydrogen_ion,water,unfltrd calcd,mg/L(00191)',
'Dissolved_oxygen,(mg/L)(00300)',
'Dis- solvedoxygen,percentof sat-uration(00301)',
'pH, water,unfltrd field, std units(00400)',
'Carbondioxide water,unfltrd mg/L(00405)',
'Bicarbonate,wat unf fixedend pt, field, mg/L(00440)',
'Carbonate,wat unf fixedend pt, field, mg/L(00445)',
'Nitrate water, fltrd, mg/L as N(00618)',
'Nitrate+nitrite water, fltrd, mg/L as N(00631)',
'Ortho-phosphate, water, fltrd, mg/L(00660)',
'Ortho-phosphate, water, fltrd, mg/L as P(00671)',
'Organic_carbon, water,unfltrd mg/L(00680)',
'Hardness, water,mg/L as CaCO3(00900)',
'Noncarb hardness,wat unf field,mg/L as CaCO3(00902)',
'Calcium water, fltrd, mg/L(00915)',
'Magnesium, water, fltrd, mg/L(00925)',
'Sodium, water, fltrd, mg/L(00930)', 'Sodium_adsorption ratio(00931)',
'Sodium fraction of cations percent(00932)',
'Potassium, water, fltrd, mg/L(00935)',
'Chloride, water, fltrd, mg/L(00940)',
'Sulfate water, fltrd, mg/L(00945)',
'Fluoride, water, fltrd, mg/L(00950)',
'Silica, water, fltrd,mg/L as SiO2(00955)',
'Iron, water, fltrd, ug/L(01046)',
'Manga- nese, water, fltrd, ug/L(01056)', 'Gage_height_meters(30207)',
'Discharge_instantaneous(m3/s)(30209)',
'Fecal coli-form,M-FC0.7u MF cfu/ 100 mL(31625)',
'Fecal streptococci KF MF, cfu/ 100 mL(31673)',
'Dissolved_solids_dried @180degCwat flt mg/L(70300)',
'Dissolved_solids, sum of constituents, mg/L(70301)',
'Dissolved_solids, water, ton/d(70302)',
'Dissolved_solids, water, tons/acre-ft(70303)',
'Nitrate water, fltrd, mg/L(71851)',
'Iron, water,unfltrd ug/L(71885)', 'Stream_flow(ft3/s)',
'Gage_height(ft)', 'GH_Change(ft)', 'Discharge_ft2/s',
'Precipitation_total_in', 'Temperature_air_C', 'Gageheight_ft',
'Gageheight_ft_2', 'Datetime', 'year', 'month', 'day', 'time'],
dtype='object')SampleDatetime
1953-07-28 15:30:00 NaN
1969-04-30 16:20:00 10.0
1969-05-01 11:00:00 5.0
1975-04-19 16:30:00 0.0
1978-04-25 12:00:00 2.0
...
2021-07-14 22:45:00 NaN
2021-07-14 23:00:00 NaN
2021-07-14 23:15:00 NaN
2021-07-14 23:30:00 NaN
2021-07-14 23:45:00 NaN
Name: Color, water, fltrd, Pt-Co units(00080), Length: 76244, dtype: float64Index(['Sampling depth (ft)(00003)', 'Stream width (ft)',
'Temperature,water(C)(00010)', 'Temperature,air(C)(00020)',
'Barometric pressure, (mmHg)(00025)', 'Surface area,(mi2)(00049)',
'Instantaneous_discharge(ft3/s)(00061)', 'Gageheight_feet(00065)',
'Turbidity,JTU(00070)', 'Turbidity,NTU(00076)',
...
'Discharge_ft2/s', 'Precipitation_total_in', 'Temperature_air_C',
'Gageheight_ft', 'Gageheight_ft_2', 'Datetime', 'year', 'month', 'day',
'time'],
dtype='object', length=159)['Sampling depth (ft)(00003)', 'Stream width (ft)', 'Temperature,water(C)(00010)', 'Temperature,air(C)(00020)', 'Barometric pressure, (mmHg)(00025)', 'Surface area,(mi2)(00049)', 'Instantaneous_discharge(ft3/s)(00061)', 'Gageheight_feet(00065)', 'Turbidity,JTU(00070)', 'Turbidity,NTU(00076)', 'Color, water, fltrd, Pt-Co units(00080)', 'Specific conductance,wat unfuS/cm @25 degC(00095)', 'Hydrogen_ion, water,unfltrd calcd, mg/L(00191)', 'Dissolved_oxygen,(mg/L)(00300)', 'Dissolved_oxygen,percentof sat-uration(00301)', 'pH, water,unfltrd field, std units(00400)', 'pH, water,unfltrd lab, std units(00403)', 'Carbon_dioxide water,unfltrd mg/L(00405)', 'Bicarbonate,wat unf fixedend pt, field, mg/L(00440)', 'Carbonate,wat unf fixedend pt, field, mg/L(00445)', 'Peri-phytonbiomass ashweight, g/m2(00572)', 'Peri-phytonbiomass dryweight, g/m2(00573)', 'Total nitrogen, water,unfltrd mg/L(00600)', 'Total nitrogen, water, fltrd, mg/L(00602)', 'Organic nitrogen, water,unfltrd mg/L(00605)', 'Organic nitrogen, water, fltrd, mg/L(00607)', 'Ammonia water, fltrd, mg/L as N(00608)', 'Ammonia water,unfltrd mg/L as N(00610)', 'Nitrite water, fltrd, mg/L as N(00613)', 'Nitrate water, fltrd, mg/L as N(00618)', 'Ammonia + org-N, water, fltrd, mg/L as N(00623)', 'Ammonia + org-N,sus sed total, mg/L as N(00624)', 'Ammonia + org-N, water,unfltrd mg/L as N(00625)', 'Nitrate + nitrite water,unfltrd mg/L as N(00630)', 'Nitrate + nitrite water, fltrd, mg/L as N(00631)', 'Phosphate, water,unfltrd mg/L(00650)', 'Orthophosphate, water, fltrd, mg/L(00660)', 'Phosphorus, water,unfltrd mg/L as P(00665)', 'Phosphorus, water, fltrd, mg/L as P(00666)', 'Orthophosphate, water, fltrd, mg/L as P(00671)', 'Organiccarbon, water,unfltrd mg/L(00680)', 'Organiccarbon, water, fltrd, mg/L(00681)', 'Organiccarbon, suspndsedimnt total, mg/L(00689)', 'Hardness, water,mg/L as CaCO3(00900)', 'Noncarb hardness,wat unf field,mg/L as CaCO3(00902)', 'Calcium water, fltrd, mg/L(00915)', 'Magnesium, water, fltrd, mg/L(00925)', 'Sodium, water, fltrd, mg/L(00930)', 'Sodium adsorption ratio(00931)', 'Sodium fraction of cations percent(00932)', 'Sodium + potassium, water, fltrd, mg/L as Na(00933)', 'Potassium, water, fltrd, mg/L(00935)', 'Chloride, water, fltrd, mg/L(00940)', 'Sulfate water, fltrd, mg/L(00945)', 'Fluoride, water, fltrd, mg/L(00950)', 'Silica, water, fltrd,mg/L as SiO2(00955)', 'Arsenic water, fltrd, ug/L(01000)', 'Arsenic suspndsedimnt total, ug/L(01001)', 'Arsenic water,unfltrd ug/L(01002)', 'Barium, water, fltrd, ug/L(01005)', 'Barium, suspndsedimntrecover -able, ug/L(01006)', 'Barium, water,unfltrdrecover -able, ug/L(01007)', 'Beryllium, water, fltrd, ug/L(01010)', 'Cadmium water, fltrd, ug/L(01025)', 'Cadmium suspndsedimntrecover -able, ug/L(01026)', 'Cadmium water,unfltrd ug/L(01027)', 'Chromium, water, fltrd, ug/L(01030)', 'Chromium, suspndsedimntrecover -able, ug/L(01031)', 'Chromium, water,unfltrdrecover -able, ug/L(01034)', 'Cobalt water, fltrd, ug/L(01035)', 'Cobalt suspndsedimntrecover -able, ug/L(01036)', 'Cobalt water,unfltrdrecover -able, ug/L(01037)', 'Copper, water, fltrd, ug/L(01040)', 'Copper, suspndsedimntrecover -able, ug/L(01041)', 'Copper, water,unfltrdrecover -able, ug/L(01042)', 'Iron, suspndsedimntrecover -able, ug/L(01044)', 'Iron, water,unfltrdrecover -able, ug/L(01045)', 'Iron, water, fltrd, ug/L(01046)', 'Lead, water, fltrd, ug/L(01049)', 'Lead, suspndsedimntrecover -able, ug/L(01050)', 'Lead, water,unfltrdrecover -able, ug/L(01051)', 'Manganese, suspndsedimntrecover -able, ug/L(01054)', 'Manganese, water,unfltrdrecover -able, ug/L(01055)', 'Manganese, water, fltrd, ug/L(01056)', 'Molybdenum, water, fltrd, ug/L(01060)', 'Nickel, water, fltrd, ug/L(01065)', 'Nickel, suspndsedimntrecover -able, ug/L(01066)', 'Nickel, water,unfltrdrecover -able, ug/L(01067)', 'Silver, water, fltrd, ug/L(01075)', 'Silver, suspndsedimntrecover -able, ug/L(01076)', 'Silver, water,unfltrdrecover -able, ug/L(01077)', 'Strontium, water, fltrd, ug/L(01080)', 'Vanadium, water, fltrd, ug/L(01085)', 'Zinc, water, fltrd, ug/L(01090)', 'Zinc, suspndsedimntrecover -able, ug/L(01091)', 'Zinc, water,unfltrdrecover -able, ug/L(01092)', 'Aluminum, water, fltrd, ug/L(01106)', 'Lithium water, fltrd, ug/L(01130)', 'Selenium, water, fltrd, ug/L(01145)', 'Selenium, suspndsedimnt total, ug/L(01146)', 'Selenium, water,unfltrd ug/L(01147)', 'Gage height above datum meters(30207)', 'Discharge,instantaneous m3/s(30209)', 'Fecal coli- form, M-FC0.45uMF cfu/ 100 mL(31616)', 'Fecal coli- form, M-FC0.7u MF cfu/ 100 mL(31625)', 'Fecal strep-tococci KF MF, cfu/ 100 mL(31673)', 'Fecal strep-tococcim-Enterococcus col/ 100 mL(31679)', 'Chlorophyll b periphyton,uncorr, mg/m2(32226)', 'Chlorophyll a periphyton,uncorr, mg/m2(32228)', 'Biomass peri-phyton,ashfreedrymass g/m2(49954)', 'Phytoplankton, total, cells /mL(60050)', 'Dissolved solids,dried @180degCwat flt mg/L(70300)', 'Dissolved solids,sum ofconsti-tuents, mg/L(70301)', 'Dissolved solids,water, ton/d(70302)', 'Dissolved solids,water, tons/acre-ft(70303)', 'Suspnd. sediment sievediametrpercent<0.0625 mm(70331)', 'Suspnd. sediment, sievediametrpercent<.125mm(70332)', 'Suspnd. sediment, sievediametrpercent <.25mm(70333)', 'Suspnd. sediment, sievediametrpercent <.5 mm(70334)', 'Suspnd. sediment,falldiadst watpercent<.002mm(70337)', 'Suspnd. sediment,falldiadst watpercent<.004mm(70338)', 'Suspnd. sediment,falldiadst watpercent<.008mm(70339)', 'Suspnd. sediment,falldiadst watpercent<.016mm(70340)', 'Suspnd. sediment,falldiadst watpercent<.031mm(70341)', 'Orthophosphate, water,unfltrd mg/L as P(70507)', 'Biomasschlorophyll ratio, peri-phyton, number(70950)', 'Chloro-phyll a periphyton,chromo-fluoro, mg/m2(70957)', 'Chloro-phyll b periphyton,chromo-fluoro, mg/m2(70958)', 'Ammonia water, unfltrd mg/L(71845)', 'Ammonia water, fltrd, mg/L(71846)', 'Nitrate water, fltrd, mg/L(71851)', 'Nitrite water, fltrd, mg/L as NO2(71856)', 'Manga- nese, water,unfltrd ug/L(71883)', 'Iron, water,unfltrd ug/L(71885)', 'Phosphorus, water,unfltrd mg/L as PO4(71886)', 'Total nitrogen, water,unfltrd mg/L as NO3(71887)', 'Mercury water, fltrd, ug/L(71890)', 'Mercury suspndsedimntrecover -able, ug/L(71895)', 'Mercury water,unfltrdrecover -able, ug/L(71900)', 'Suspended sediment concentration mg/L(80154)', 'Suspended sediment discharge, ton/d(80155)', 'Carbonate,wat unfinf tit field,mg/L as CaCO3(99430)', 'Bicarbonate,wat unfinfl pt titr., field, mg/L(99440)', 'Year', 'Temperature_water_(C)', 'Discharge_(ft3/s)', 'Stream_flow(ft3/s)', 'Gage_height(ft)', 'GH_Change(ft)', 'Discharge_ft2/s', 'Precipitation_total_in', 'Temperature_air_C', 'Gageheight_ft', 'Gageheight_ft_2', 'Datetime', 'year', 'month', 'day', 'time']
['Sampling depth (ft)(00003)', 'Stream width (ft)', 'Temperature,water(C)(00010)', 'Temperature,air(C)(00020)', 'Barometric pressure, (mmHg)(00025)', 'Surface area,(mi2)(00049)', 'Instantaneous_discharge(ft3/s)(00061)', 'Gageheight_feet(00065)', 'Turbidity,JTU(00070)', 'Turbidity,NTU(00076)', 'Color, water, fltrd, Pt-Co units(00080)', 'Specific conductance,wat unfuS/cm @25 degC(00095)', 'Hydrogen_ion, water,unfltrd calcd, mg/L(00191)', 'Dissolved_oxygen,(mg/L)(00300)', 'Dissolved_oxygen,percentof sat-uration(00301)', 'pH, water,unfltrd field, std units(00400)', 'pH, water,unfltrd lab, std units(00403)', 'Carbon_dioxide water,unfltrd mg/L(00405)', 'Bicarbonate,wat unf fixedend pt, field, mg/L(00440)', 'Carbonate,wat unf fixedend pt, field, mg/L(00445)', 'Peri-phytonbiomass ashweight, g/m2(00572)', 'Peri-phytonbiomass dryweight, g/m2(00573)', 'Total nitrogen, water,unfltrd mg/L(00600)', 'Total nitrogen, water, fltrd, mg/L(00602)', 'Organic nitrogen, water,unfltrd mg/L(00605)', 'Organic nitrogen, water, fltrd, mg/L(00607)', 'Ammonia water, fltrd, mg/L as N(00608)', 'Ammonia water,unfltrd mg/L as N(00610)', 'Nitrite water, fltrd, mg/L as N(00613)', 'Nitrate water, fltrd, mg/L as N(00618)', 'Ammonia + org-N, water, fltrd, mg/L as N(00623)', 'Ammonia + org-N,sus sed total, mg/L as N(00624)', 'Ammonia + org-N, water,unfltrd mg/L as N(00625)', 'Nitrate + nitrite water,unfltrd mg/L as N(00630)', 'Nitrate + nitrite water, fltrd, mg/L as N(00631)', 'Phosphate, water,unfltrd mg/L(00650)', 'Orthophosphate, water, fltrd, mg/L(00660)', 'Phosphorus, water,unfltrd mg/L as P(00665)', 'Phosphorus, water, fltrd, mg/L as P(00666)', 'Orthophosphate, water, fltrd, mg/L as P(00671)', 'Organiccarbon, water,unfltrd mg/L(00680)', 'Organiccarbon, water, fltrd, mg/L(00681)', 'Organiccarbon, suspndsedimnt total, mg/L(00689)', 'Hardness, water,mg/L as CaCO3(00900)', 'Noncarb hardness,wat unf field,mg/L as CaCO3(00902)', 'Calcium water, fltrd, mg/L(00915)', 'Magnesium, water, fltrd, mg/L(00925)', 'Sodium, water, fltrd, mg/L(00930)', 'Sodium adsorption ratio(00931)', 'Sodium fraction of cations percent(00932)', 'Sodium + potassium, water, fltrd, mg/L as Na(00933)', 'Potassium, water, fltrd, mg/L(00935)', 'Chloride, water, fltrd, mg/L(00940)', 'Sulfate water, fltrd, mg/L(00945)', 'Fluoride, water, fltrd, mg/L(00950)', 'Silica, water, fltrd,mg/L as SiO2(00955)', 'Arsenic water, fltrd, ug/L(01000)', 'Arsenic suspndsedimnt total, ug/L(01001)', 'Arsenic water,unfltrd ug/L(01002)', 'Barium, water, fltrd, ug/L(01005)', 'Barium, suspndsedimntrecover -able, ug/L(01006)', 'Barium, water,unfltrdrecover -able, ug/L(01007)', 'Beryllium, water, fltrd, ug/L(01010)', 'Cadmium water, fltrd, ug/L(01025)', 'Cadmium suspndsedimntrecover -able, ug/L(01026)', 'Cadmium water,unfltrd ug/L(01027)', 'Chromium, water, fltrd, ug/L(01030)', 'Chromium, suspndsedimntrecover -able, ug/L(01031)', 'Chromium, water,unfltrdrecover -able, ug/L(01034)', 'Cobalt water, fltrd, ug/L(01035)', 'Cobalt suspndsedimntrecover -able, ug/L(01036)', 'Cobalt water,unfltrdrecover -able, ug/L(01037)', 'Copper, water, fltrd, ug/L(01040)', 'Copper, suspndsedimntrecover -able, ug/L(01041)', 'Copper, water,unfltrdrecover -able, ug/L(01042)', 'Iron, suspndsedimntrecover -able, ug/L(01044)', 'Iron, water,unfltrdrecover -able, ug/L(01045)', 'Iron, water, fltrd, ug/L(01046)', 'Lead, water, fltrd, ug/L(01049)', 'Lead, suspndsedimntrecover -able, ug/L(01050)', 'Lead, water,unfltrdrecover -able, ug/L(01051)', 'Manganese, suspndsedimntrecover -able, ug/L(01054)', 'Manganese, water,unfltrdrecover -able, ug/L(01055)', 'Manganese, water, fltrd, ug/L(01056)', 'Molybdenum, water, fltrd, ug/L(01060)', 'Nickel, water, fltrd, ug/L(01065)', 'Nickel, suspndsedimntrecover -able, ug/L(01066)', 'Nickel, water,unfltrdrecover -able, ug/L(01067)', 'Silver, water, fltrd, ug/L(01075)', 'Silver, suspndsedimntrecover -able, ug/L(01076)', 'Silver, water,unfltrdrecover -able, ug/L(01077)', 'Strontium, water, fltrd, ug/L(01080)', 'Vanadium, water, fltrd, ug/L(01085)', 'Zinc, water, fltrd, ug/L(01090)', 'Zinc, suspndsedimntrecover -able, ug/L(01091)', 'Zinc, water,unfltrdrecover -able, ug/L(01092)', 'Aluminum, water, fltrd, ug/L(01106)', 'Lithium water, fltrd, ug/L(01130)', 'Selenium, water, fltrd, ug/L(01145)', 'Selenium, suspndsedimnt total, ug/L(01146)', 'Selenium, water,unfltrd ug/L(01147)', 'Gage height above datum meters(30207)', 'Discharge,instantaneous m3/s(30209)', 'Fecal coli- form, M-FC0.45uMF cfu/ 100 mL(31616)', 'Fecal coli- form, M-FC0.7u MF cfu/ 100 mL(31625)', 'Fecal strep-tococci KF MF, cfu/ 100 mL(31673)', 'Fecal strep-tococcim-Enterococcus col/ 100 mL(31679)', 'Chlorophyll b periphyton,uncorr, mg/m2(32226)', 'Chlorophyll a periphyton,uncorr, mg/m2(32228)', 'Biomass peri-phyton,ashfreedrymass g/m2(49954)', 'Phytoplankton, total, cells /mL(60050)', 'Dissolved solids,dried @180degCwat flt mg/L(70300)', 'Dissolved solids,sum ofconsti-tuents, mg/L(70301)', 'Dissolved solids,water, ton/d(70302)', 'Dissolved solids,water, tons/acre-ft(70303)', 'Suspnd. sediment sievediametrpercent<0.0625 mm(70331)', 'Suspnd. sediment, sievediametrpercent<.125mm(70332)', 'Suspnd. sediment, sievediametrpercent <.25mm(70333)', 'Suspnd. sediment, sievediametrpercent <.5 mm(70334)', 'Suspnd. sediment,falldiadst watpercent<.002mm(70337)', 'Suspnd. sediment,falldiadst watpercent<.004mm(70338)', 'Suspnd. sediment,falldiadst watpercent<.008mm(70339)', 'Suspnd. sediment,falldiadst watpercent<.016mm(70340)', 'Suspnd. sediment,falldiadst watpercent<.031mm(70341)', 'Orthophosphate, water,unfltrd mg/L as P(70507)', 'Biomasschlorophyll ratio, peri-phyton, number(70950)', 'Chloro-phyll a periphyton,chromo-fluoro, mg/m2(70957)', 'Chloro-phyll b periphyton,chromo-fluoro, mg/m2(70958)', 'Ammonia water, unfltrd mg/L(71845)', 'Ammonia water, fltrd, mg/L(71846)', 'Nitrate water, fltrd, mg/L(71851)', 'Nitrite water, fltrd, mg/L as NO2(71856)', 'Manga- nese, water,unfltrd ug/L(71883)', 'Iron, water,unfltrd ug/L(71885)', 'Phosphorus, water,unfltrd mg/L as PO4(71886)', 'Total nitrogen, water,unfltrd mg/L as NO3(71887)', 'Mercury water, fltrd, ug/L(71890)', 'Mercury suspndsedimntrecover -able, ug/L(71895)', 'Mercury water,unfltrdrecover -able, ug/L(71900)', 'Suspended sediment concentration mg/L(80154)', 'Suspended sediment discharge, ton/d(80155)', 'Carbonate,wat unfinf tit field,mg/L as CaCO3(99430)', 'Bicarbonate,wat unfinfl pt titr., field, mg/L(99440)', 'Year', 'Temperature_water_(C)', 'Discharge_(ft3/s)', 'Stream_flow(ft3/s)', 'Gage_height(ft)', 'GH_Change(ft)', 'Discharge_ft2/s', 'Precipitation_total_in', 'Temperature_air_C', 'Gageheight_ft', 'Gageheight_ft_2', 'Datetime', 'year', 'month', 'day', 'time']